Setting Advanced Trigger

Execute as
Specify the security context under which the trigger is executed.

Note: Support from SQL Server 2005 or later and SQL Azure.

Options

Note: SQL Azure does not support.

Encrypted
Obfuscate the text of the CREATE TRIGGER statement.

Note: Support from SQL Server 2005 or later.

Not for replication
Indicate that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.

Append
Specify that an additional trigger of an existing type should be added.